Do You Even Synapse?
Course Description
Contoso Powerlifting Federation (CPF) are in dire need to modernize their data approach. Among the tasks required by your team, you will be challenged to retrieve the source data and upload it into a modern data warehouse repository in a cleansed/modelled format to be able to report and visualize.
Learning Objectives
The purpose of this hack is to learn:
- About some of the features of Azure Synapse
- The power of data visualization
- How to add additional data into Azure Synapse
- How Machine Learning is incorporated
About this Course
Course Outline
- Challenge 0: Pre-requisites – Ready, Set, GO!
- Prepare your workstation to work with Azure
- Challenge 1: Gathering Open Powerlifting Data
- Retrieve data and upload to Azure using a storage service
- Challenge 2: Load data into a relational database/warehouse
- Loading the data
- Challenge 3: Visualization
- Visualizing the data
- Challenge 4: Incremental Loads
- Load incrementals
- Challenge 5: Mask Data for Privacy
- Putting your mask on
- Challenge 6: Add New Data Source(s)
- Additional data sources
- Challenge 7: Leverage Machine Learning
- The machines know too much!
Duration
1 Day
Prerequisites
none
Level
Advanced
Product
Azure Synapse
Role
Database Administrator